Deltek Acumen 8.6 Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Microsoft Excel Platform Integration

This topic describes options and information specific to Microsoft Excel files, Deltek Cobra's CAP report, and ARES PRISM G2 data.

Acumen's interface with Microsoft Excel provides an open and flexible means of linking to external data. Any data that can be stored as an XLS or XLSX file can be imported into Acumen for analysis.

When you link to an Excel file, an Options dialog box displays. Use the fields in this dialog box to:
  • Select the worksheet from the Excel file that you want to import.
  • Create mappings between the columns in the XLS spreadsheet and the fields within your Acumen workbook. Excel fields are auto-mapped to Acumen fields if the field names are consistent between the two applications.

In addition to importing standard excel files, you can use the Microsoft Excel option in the Get External Data From menu group on the S1 // Projects tab to import ARES PRISM G2 or Deltek Cobra CAP Earned Value data.